load data
truncate                                       
into table CRST_RCV_PARAMETERS
fields terminated by "	"                      
trailing nullcols 
( ORGANIZATION_ID                 ,
  LAST_UPDATE_DATE                DATE 'YYYYMMDD HH24:MI:SS',
  LAST_UPDATED_BY                 ,
  CREATION_DATE                   DATE 'YYYYMMDD HH24:MI:SS',
  CREATED_BY                      ,
  LAST_UPDATED_LOGIN              ,
  QTY_RCV_TOLERANCE               ,
  QTY_RCV_EXCEPTION_CODE          ,
  ENFORCE_SHIP_TO_LOCATION_CODE   ,
  ALLOW_EXPRESS_DELIVERY_FLAG     ,
  DAYS_EARLY_RECEIPT_ALLOWED      ,
  DAYS_LATE_RECEIPT_ALLOWED       ,
  RECEIPT_DAYS_EXCEPTION_CODE     ,
  RECEIVING_ROUTING_ID            ,
  ALLOW_SUBSTITUTE_RECEIPTS_FLAG  ,
  ALLOW_UNORDERED_RECEIPTS_FLAG   ,
  BLIND_RECEIVING_FLAG            ,
  REQUEST_ID                      ,
  PROGRAM_APPLICATION_ID          ,
  PROGRAM_ID                      ,
  PROGRAM_UPDATE_DATE             DATE 'YYYYMMDD HH24:MI:SS',
  RECEIVING_ACCOUNT_ID            ,
  ALLOW_CASCADE_TRANSACTIONS      ,
  GLOBAL_ATTRIBUTE1               ,
  GLOBAL_ATTRIBUTE2               ,
  GLOBAL_ATTRIBUTE3               ,
  GLOBAL_ATTRIBUTE4               ,
  GLOBAL_ATTRIBUTE5               ,
  GLOBAL_ATTRIBUTE6               ,
  GLOBAL_ATTRIBUTE7               ,
  GLOBAL_ATTRIBUTE8               ,
  GLOBAL_ATTRIBUTE9               ,
  GLOBAL_ATTRIBUTE10              ,
  GLOBAL_ATTRIBUTE11              ,
  GLOBAL_ATTRIBUTE12              ,
  GLOBAL_ATTRIBUTE13              ,
  GLOBAL_ATTRIBUTE14              ,
  GLOBAL_ATTRIBUTE15              ,
  GLOBAL_ATTRIBUTE16              ,
  GLOBAL_ATTRIBUTE17              ,
  GLOBAL_ATTRIBUTE18              ,
  GLOBAL_ATTRIBUTE19              ,
  GLOBAL_ATTRIBUTE20              ,
  GLOBAL_ATTRIBUTE_CATEGORY       ,
  RECEIPT_ASN_EXISTS_CODE         ,
  USER_DEFINED_RECEIPT_NUM_CODE   ,
  MANUAL_RECEIPT_NUM_TYPE         ,
  NEXT_RECEIPT_NUM 
)
